Group(SortInfo[],IComparer) Method

Groups the rows with the specified sort information and specified comparer.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub Group( _
   ByVal sortInfo() As SortInfo, _
   ByVal groupComparer As IComparer _
)

'Usage
 
Dim instance As GroupDataModel
Dim sortInfo() As SortInfo
Dim groupComparer As IComparer
 
instance.Group(sortInfo, groupComparer)

public void Group( 
   SortInfo[] sortInfo,
   IComparer groupComparer
)

Parameters

sortInfo: Sort information
groupComparer: Comparer

Example

This example groups the data model.

private void button1_Click(object sender, EventArgs e)
{
FarPoint.Web.Spread.Model.GroupDataModel gm = new FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel);
FarPoint.Web.Spread.SortInfo[] sort = new FarPoint.Web.Spread.SortInfo[1];
sort[0] = new FarPoint.Web.Spread.SortInfo(0, true);
gm.Group(sort, System.Collections.Comparer.Default);
FpSpread1.ActiveSheetView.DataModel = gm;

String msg = gm.Groups.Count.ToString();
Response.Write("alert('" + msg + "')");
}

Visual Basic

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim gm As New FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel)
Dim sort(0) As FarPoint.Web.Spread.SortInfo
sort(0) = New FarPoint.Web.Spread.SortInfo(0, True)
gm.Group(sort, System.Collections.Comparer.Default)
FpSpread1.ActiveSheetView.DataModel = gm
String msg = gm.Groups.Count.ToString();
Response.Write("alert('" & msg & "')");
End Sub

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

GroupDataModel Class
GroupDataModel Members
Overload List